@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: '메뉴관리 I_VIEW'

define view entity ymoon_i_menu as select from ymoon_t_menu
association of many to one ymoon_i_form as _Form on $projection.FormId = _Form.FormId
association of many to one ymoon_i_menu as _Parent on $projection.FormId = _Parent.FormId and $projection.ParentMenu = _Parent.MenuId
association of many to many ymoon_i_menu as _Sub on $projection.FormId = _Sub.FormId and $projection.MenuId = _Sub.ParentMenu
{
    key form_id as FormId,
    key menu_id as MenuId,
    parent_menu as ParentMenu,
    menu_name as MenuName,
    menu_seq as MenuSeq,
    create_at as CreateAt,
    create_by as CreateBy,
    changed_at as ChangedAt,
    changed_by as ChangedBy,
    @Semantics.systemDateTime.localInstanceLastChangedAt: true
    local_last_changed_at as LocalLastChangedAt,
    @Semantics.user.localInstanceLastChangedBy: true
    local_last_changed_by as LocalLastChangedBy,
    _Form,
    _Parent,
    _Sub
}
